package com.ztp.lib.server;

public class UsersTableShema {
	public static final String DB_NAME  = "Users.db";
	public static final String TBL_NAME  = "Users";
	
	public static final String USERID_C = "userid";
	public static final String USERPASS_C = "userpassword";
	public static final String HOMEDIR_C = "homedirectory";
	public static final String ENABLE_C = "enableflag";
	public static final String WRITE_C = "writepermission";
	public static final String IDLETIME_C = "idletime";
	public static final String UPRATE_C = "uploadrate";
	public static final String DOWNRATE_C = "downloadrate";
	public static final String MAXLOGIN_C = "maxloginnumber";
	public static final String MAXLOGINPERIP_C = "maxloginperip";
	
	
	
	public static final String CREATE_STMNT = "CREATE TABLE " + TBL_NAME + "("
			+ "userid VARCHAR(64) primary key"
			+ " ,userpassword VARCHAR(64)"
			+ " ,homedirectory VARCHAR(128)"
			+ " ,enableflag BOOLAEN DEFAULT TRUE"
			+ " ,writepermission BOOLAEN DEFAULT FALSE"
			+ " ,idletime INTEGER DEFAULT 0"
			+ " ,uploadrate INTEGER DEFAULT 0"
			+ " ,downloadrate INTEGER DEFAULT 0"
			+ " ,maxloginnumber INTEGER DEFAULT 0"
			+ " ,maxloginperip INTEGER DEFAULT 0"
			+ ")";
	public static final String DROP_STMNT = "DROP TABLE IF EXISTS " + TBL_NAME ;
	
	
}
